from django.db import models


class PublicServant(models.Model):
    class Meta:
        db_table = 'public_servant'
    id = models.IntegerField(primary_key=True)
    update_time = models.DateTimeField()
    create_time = models.DateTimeField()
    office = models.CharField(max_length=100)
    employer = models.CharField(max_length=100)
    position_code = models.CharField(max_length=100)
    job_title = models.CharField(max_length=200)
    written_test_category = models.CharField(max_length=200)
    job_profile = models.CharField(max_length=500)
    employment_plan = models.CharField(max_length=200)
    recruitment_object = models.CharField(max_length=200)
    educational_requirements = models.CharField(max_length=200)
    degree_requirements = models.CharField(max_length=200)
    college_requirements = models.CharField(max_length=800)
    undergraduate_requirements = models.CharField(max_length=800)
    graduate_requirements = models.CharField(max_length=800)
    gender_requirements = models.CharField(max_length=200)
    registered_requirements = models.CharField(max_length=200)
    political_outlook = models.CharField(max_length=200)
    work_years = models.CharField(max_length=200)
    position_category = models.CharField(max_length=200)
    professional_examination = models.CharField(max_length=200)
    variance_investigation = models.CharField(max_length=200)
    physical_examination = models.CharField(max_length=200)
    work_site = models.CharField(max_length=100)
    remark = models.CharField(max_length=500)
    website = models.CharField(max_length=100)
    phone = models.CharField(max_length=50)
    filename = models.CharField(max_length=100)
